ETL/Data Engineer

Job Description

JOB DESCRIPTIONRole Proficiency:Under the supervision of a Senior Lead analyze and develop applications in assigned area of responsibility on ERP/CRM systems and design solutions.Outcomes:

1. Optimise efficiency cost and quality by identifying opportunities for automation/process improvements and agile delivery models
2. Learn technology business/system domain and as recommended by the project/account
3. Contribute to ERP/CRM Practice related activities like (but not limited to) assembling content for case studies contributing to reusability coordinating internal seminars and conduct knowledge sharing sessions organizing sessions during and participating in hackathons etc.
4. Identify the problem patterns and improve the technical design of the application/system
5. Select appropriate technical options for development such as reusing improving or reconfiguration of existing components.
6. Independently analyze design develop and test functionalities
7. Develop technical documents such as Functional Design Specifications Deployment documentation
8. Perform design document reviews peer code reviews and suggest code improvements
9. A single point of contact for the build and deployment issues and resolving on time
10. Responsible for code/configuration changes to production environment to resolve any issues post production move
11. Independently manage client environments/perform installation related activities
12. Perform root cause analysis technical troubleshooting architecture resolve performance issues
13. Mentor juniors for client discussions and day to day activities and basic administrative tasks
14. Perform other duties as assigned or requested.
15. Influence and improve customer satisfaction through things like (but not limited to) offering suggestions for code refactoring and for small improvements in business processes. complete sprint deliverables ahead of schedule helping client architects and product owners by way of design suggestions and/or explaining functionality to business stakeholders etc
16. Self-learning and implement new features released in ERP/CRM wherever possible.
17. Set goals in NorthStar and timely measure the progress and update accordingly.

Measures of Outcomes:

1. Number of applicable technical/domain certifications completed
2. Adherence to process and standards (coding standards)
3. Number of mandatory training (Industry/Technology specific trainings UST mandatory trainings) completed
4. Quick turnaround of production bugs
5. Adherence to schedule / timelines
6. Number of mid-size requirements solutioned and implemented
7. Number of issues resolved
8. Number of innovative industry/technology specific ideas submitted
9. Number of positive feedback received from client (client appreciation emails)
10. Number of suggestions/implementation of new features/standards/framework for client.
11. Resource utilization throughout the year

Outputs Expected:Requirement:

1. Understand the requirements/user stories

Estimate:

1. Estimate time effort resource dependence for ones own work and for others work including for modules. Follow scrum ceremonies.
2. Participate in preparing RFPs and estimations in ERP/CRM Practice

Design:

1. Understand the design/LLD and link it to requirements/user stories

Configuration and Coding:

1. Adhere to coding standards and follow ERP/CRM best practices. Develop code independently.
2. Review code done by peer and team.

Test:

1. Create and conduct unit testing.
2. Test class coverage above 95%.

Manage Defects:

1. Perform defect RCA and mitigation
2. Identify defect trends and take proactive measures to improve quality

Client Interaction:

1. Effectively interact with customers and articulate their inputs

Manage Project:

1. Manage delivery of modules and/or manage user stories

Documentation:

1. Create/review templates checklists guidelines standards for design/process/development
2. Create/review deliverable documents. Design documentation requirements t test cases and results
3. Document ones own work

Status Reporting:

1. Report status of tasks assigned
2. Comply with project related reporting standard and process

Manage knowledge:

1. Contribute project related documents share point libraries client universities
2. Review the reusable documents created by the team

Release:

1. Follow and monitor release process

Customer interaction:

1. Clarify requirements and provide guidance to development team
2. Present design options to customers
3. Implementation reviews with stakeholders.

Domain relevance:

1. Develop feature / component with good understanding of the business problem being addressed for the client

Recruitment and Onboarding:

1. Part of technical screening team for recruiting candidates for A2/A3 Band.
2. People management skills - manage onboard new team members guide reportees and provide timely feedback.

Manage/Mentoring Team:

1. Mentor junior developers in the team
2. Set goals and provide feedback

Skill Examples:

1. Explain and communicate the design / development to the customer
2. Perform and evaluate test results against product specifications
3. Break down complex problems into logical components
4. Manage and guarantee high levels of cohesion and quality
5. Estimate effort time required for own work
6. Perform and evaluate test in the customer or target environment
7. Make quick decisions on technical/project related challenges
8. Team player capabilities and can manage a team mentor and handle people related issues with the team
9. Maintain high motivation levels and positive dynamics in the team.
10. Set goals for self and team. Provide feedback for team members
11. Create and articulate impactful technical presentations
12. Follow high level of business etiquette in emails and other business communication
13. Drive conference calls with customers and answer customer questions
14. Proactively ask for and help
15. Ability to work under pressure determine dependencies risks facilitate planning and handle multiple tasks.
16. Build confidence with customers by meeting the deliverables in time with quality.
17. Estimate effort time and resources required for developing / debugging features / components
18. Strong analytical and problem-solving abilities
19. Ability to advise on best practices and approaches to the team and the client
20. Ability to prepare test data and steps for unit integration and production testingas per project needs.
21. Strong and effective written and verbal communication skills.

Knowledge Examples:

Functional and technical designing on various ERP and CRM cloud platform features and automations.

1. Thorough knowledge of coding best practices and understanding the limitations of coding.
2. Experience using data loader tools.
3. Experience with production deployment and solving deployment errors.
4. Knowledge of Agile Methods - Scrum and Kanban
5. Knowledge in integrating ERP/CRM with external systems using SOAP API REST API etc.

Additional Comments:Sr ETL/Data Engineer [Project Details]: . In-depth, hands-on experience with data warehouse ETL tools and technologies such as Informatica, Snowflake/Oracle, Control-M that will be leveraged to support our ETL platform for SIE FMA. [Technology and Sub-technology] . ETL: Informatica/DataStage/Talend . Database: Snowflake/Oracle/MySQL/Teradata . Scheduler: Control-M/Apache Airflow/Autosys . Scripting Language: Python/Java/Shell/Golang [Qualifications] . Education level: BE/B.Tech/MCA . Experience: 4-6 yrs. experience [Job Overview]: . Work with developers and architects to advise on standards and best practices. . Good understanding of Database architectures and data models. . Creating and maintaining technical documentation. . Actively work with onshore team. . Exposure of working in Agile model. . Participate in weekdays & weekend on-call Support rotation and off-hours maintenance windows. . Ready to work in 2 shifts on rotational basis (Morning and afternoon). [Primary Skills]: . Application expertise: . Very good knowledge on ETL Architecture and development (Informatica preferred). . Very good knowledge on Data warehouse Concepts and Architecture. . Very Good Knowledge on SQL concepts (Oracle, MySQL). . Knowledge on Snowflake database . Good exposure on Enterprise Schedule (like Control-M) . Should have exposure to Extensive Operations Support on the above-mentioned applications. . Should be ready to work in shifts . Programming & Development Skills: . Strong scripting skills (Unix, python etc...) . Coordinate with the Systems Engineering team to plan and execute system upgrades of existing warehouse application tools. . Maintain the software development disciplines including version control using Git repository [Good to have Skills]: . AWS cloud knowledge. . Good understanding of AWS data services such as Lambda, EMT, Athena, Glue, Redshift . Preparing Dashboards and metrics collection using tools such as Grafana, Datadog . Automation of monitoring frameworks for key business jobs [Responsibilities and Duties]: . Work with developers and architects to advise on standards and best practices. . Good understanding of Database architectures and data models. . Creating and maintaining technical documentation. . Actively work with onshore team. . Exposure of working in Agile model. . Participate in weekdays & weekend on-call Support rotation and off-hours maintenance windows. . Ready to work in 2 shifts on rotational basis (Morning and afternoon). [Keywords] . Informatica, Snowflake, Oracle PL/SQL, Control-M

Keyskills :
GolangUnixSoap ApiInformaticaRest ApiApache AirflowLambdaShellMySQLAgileScrumTalendOraclePythonAWSJavaAutosysRedshiftDataStagesnowflakeControl-MKanbanEmtTeradataGlueAthena