AEM Developer

Role Title: ETL Architect
Location: Nashville, TN (Initial remote ok)
Duration: 6 month

Job Description
· Able to design and architect ETL solutions
· Expert developer
· Understands Software Development Lifecycle (Requirements, Functional Design, Technical Design, Development, Testing, implementation
· Analytical Thinker
· Quick learner
· Can lead other developers and review / verify work to meet requirements and for performance

Any of the following:
· Oracle SQL, PL/SQL, Exp/Imp
· Snowflake SQL / Procedures (Java)
· Linux / Unix
· XML
· 1010data Macro code

Actively participate in architecture discussions and contribute to design decisions
· Assist the development team on service or design of applications for better maintainability, quality and software reuse using software development life cycle (SDLC).
· Confer with systems analysts, programmers and others to design and gather information on project limitations and capabilities, performance requirements, interfaces, and technical feasibility.
· Work with the team members to complete project planning, coding and testing to ensure project delivery on time and proactively participate in code and test case reviews for bug-free release and implementation.
· Assist project management in tracking project progress, prioritize work, develop time estimates and work plans and resolve or escalate any unforeseen issues, if necessary.
· Promote code quality and coding standards for all developers by implementing a modern version source code control (GITLAB)
· Guide other developers in familiarizing themselves with the existing data structure, data flow and help them understand how the new solution fits in the current process.
· Coordinate project activities and tasks, as well as dependent deliverables for successful project implementation.

Translate business and technical architecture requirements into design specifications for the development team.
· Work closely with business and solution architect teams during the design phase by analyzing the business requirement and existing data structure and helping identify an optimal technical solution that is compatible with the existing business processes, ensuring no or minimal performance issues.
· Gather and interpret functional specifications and user requirements.
· Create the technical system documentation outlining all business and architectural requirements. This includes the design of logical and physical database structures, design of user interfaces and system features, and identification of new application programs, or modifications to existing programs. The tools used include data flow diagrams and E/R data modeling.
· Apply database normalization and/or dimensional modeling techniques, data modeling, and other relevant design techniques to convert the business requirements to technical document used by the development team.
· Propose the best suitable technical strategy considering various factors such as time, size etc. to resolve the business problem.
· Develop technical system documentation outlining all business and architectural requirements that need modification to application programs using Oracle PL/SQL,1010Data Macro language, Java and Unix shell scripting.

Design and code data analytics and data science software sometimes from the ground up as well as correctly sizing the solution to suit business needs.
· Diagnose and troubleshoot performance bottlenecks, data transformation optimization initiatives and mentor the team in troubleshooting and resolving performance-related issues.
· Design and develop automated batch processing applications to process jobs including working with third party software to schedule and monitor jobs.
· Develop and maintain historical reports needed across the different business functions and develop simplified dashboards that allow for easy generation of ad hoc historical reporting and queries.
· Implementation of advanced analytics solutions that allow for diagnostic reporting and analysis, automation of business queries and facilitation of deeper insights from available data
· Maintenance of the metrics, reports algorithms and analytical models used to deliver reactive proactive and predictive insights
· Serve as member of the Agile/Kanban Development team composed of onshore and offshore members; participate in agile ceremonies: daily scrums, sprint planning, daily stand-ups, iteration review, and retrospective.
· Prepare unit test cases with all possible combination of scenarios and participate in the unit testing, functional testing, system testing and performance testing through production implementation and troubleshooting.
· Resolve bug fixes and defects found during system and user acceptance testing.
· Prepare implementation scripts and documents to deploy code into production environment.
· Provide production support after implementation.
· Provide documentation, system and post-implementation support including data fixes, user clarifications and critical night-time batch processing jobs.
Work on the periodic maintenance release of applications, including enhancements and defects, for better maintainability and software reuse and ensuring incremental improvement of the architecture of legacy systems.

Job Types: Full-time, Contract

Salary: $60.00 - $65.00 per hour

Schedule:

• Monday to Friday

Experience:

• ETL: 8 years (Preferred)
• Linux: 7 years (Required)

Work Location: One location

Speak with the employer
91 9700642991

Salary : $60 - $65