• Analyze functional/nonfunctional requirements and seek clarifications for a better understanding of requirements.
• Based on an understanding of the system upstream and downstream, provide feedback and inputs on gaps in requirements and technical feasibility of requirements.
• Prepare the LLD/ detailed design documents based on HLD and briefing from the Module Lead.
• Seek inputs from the developers on specific modules as applicable.
• Consolidate all modules and provide them to the Module Lead/ Architects/ Designers for review.
• Suggest changes in design on technical grounds.
• Develop components inventory for the code to be developed tying it to the nonfunctional requirements.
• Perform sampling of data to understand the character/ quality of the data (project dependent in the absence of data analyst or designer).
• Identify tools and technologies to be used in the project as well as reusable objects that could be customized for the project.
• Follow coding standards and best practices to develop code and check code quality.
• Share developed code with supervisor for review.
• Rework the code based on inputs
• Perform complex integration.

Skills: Requirements Analysis, System Feedback, Design Documentation, Collaborative Input, Design Review, Code Inventory Management, Coding Standards Adherence, Complex Integration.

• Provide periodic status updates to the supervisor and highlight/recommend any changes in design based on challenges faced.
• Anticipate unreported defects and raise the same to the supervisor.
• Conduct technical troubleshooting.
• Conduct reviews for codes created by the team.
• Develop unit test cases for each module.
• Conduct/ guide the conducting of unit and integration testing and fix defects.
• Review/ approve code to be moved to the testing environment.
• Provide support to the QA team and coordinate various phases of testing.
• Address queries raised by QA within defined timelines.
• Investigate critical defects and establish the need for fixing.
• Raise issues to leads/QA.
• Report defect status as per project standard process within agreed timelines.
• Consolidate the test results and share them with a supervisor.

Skills: Status Reporting, Defect Anticipation, Troubleshooting, Code Review, Test Case Development, Testing Coordination, QA Support, Result Consolidation.

• Share revised code with supervisor for review.
• Assist team lead and project manager on estimates around defect fixes.
• Maintain versions of the code or consolidate versions maintained by the Developers.
• Provide support as required to the Administrators during configuration, code backups, deployment etc.
• Assess and create a deployment/rollback plan.
• Validate if all the components have been migrated and the right version is checked in.
• Maintain deployment tracker.
• Perform sanity checks post-deployment to ensure smooth production.
• Share activity status with supervisor and highlight concerns if any.
• Project Execution Monitoring and Closure (Support to Project Management activities)
• Monitor the work of the developers and share the work achieved with them.
• Guide the developers in identifying, preparing and conducting unit test cases and fixing defects based on results.

Skills: Code Review, Estimate Assistance, Version Control, Deployment Support, Deployment Planning, Validation Checks, Sanity Testing, Project Monitoring.

• Lead the evaluation of the acquired support system data migration activities, which involves: working closely with business partners to define (incl. field mapping) what data is required to be moved from the acquired customer support system into ServiceNow.
• Review impact on upstream and downstream applications and lead any discussions around potential changes 
• Work closely with BI technical SMEs to import the remaining data into the data warehouse.
• Translate functional requirements into technical specifications for ETL development.
• Design data migration processes including collection of source data, data transfer mechanism and data upload mechanism ensuring the migration can happen within an acceptable timeframe
• Participate in and lead the ETL development.
• Write validation scripts to run over the Staging tables to report any invalid data.
• Identify and test for bugs and bottlenecks in the ETL solution.
• Execution of data migrations, which includes building the implementation plan.
• Maintain appropriate levels of data security and privacy relating to customer data.
• Complete and encourage others to complete administrative tasks in an accurate and timely manner.
• Support effective communication, and encourage and provide constructive feedback.
• Adhere to IT Change Management and best practices
• Investigate and fix advanced (3rd level) Data/Application issues

Skills: Migration Leadership, Impact Analysis, BI Collaboration, Specification Translation, ETL Design, Validation Scripting, Bug Testing, Data Security.

• Requirement discussion with business users and up/downstream teams
• Lead the team to complete ETL/data integration tasks, following the design conventions
• Identify potential risks as early as possible and avoid delivery risks
• Complete the ETL program with ETL tools like Informatica
• Coordinate with business users or up/downstream teams for UAT/E2E/SIT
• Lead team to follow the SDLC process for delivery
• Engage stakeholders for SDLC documents sign-off
• Support product owners for ad-hoc data integration queries
• Responsible for requirement gathering, analysis, and documentation
• Co-ordinate onsite and Offshore team
• Responsible for reviewing design and all project-related deliverables to ensure adherence to standards and best practices
• Responsible for making sure the requirements are defined and properly documented
• Responsible for ensuring the final application meets the defined functional requirements
• Coordinate with other Client business user groups and subject matter experts directly

Skills: Requirement Elicitation, Team Leadership, Risk Management, ETL Proficiency, UAT Coordination, SDLC Adherence, Stakeholder Engagement, Documentation Compliance.

• Demonstrates a detailed knowledge and understanding of large Enterprise Data Warehouse, Data Mart, and ODS.
• Strong knowledge of DW Concepts, Dimensional Modeling, SCD2, Data modeling, ETL/ELT, Data, and Information Management.
• Strong in RDBMS and SQL Knowledge.
• Expert in Data Integration, Data profiling, Data Quality and Metadata Management, and Data Pipeline.
• Proficiency in translating high-level business problem statements to detailed technical designs/solutions.
• Experience in Agile Development and CI/CD.
• Ability to take ownership and lead/drive end-to-end deliverables.
• ETL/ELT development experience and ETL/ELT Architecture experience 
• Ability to resolve complex ETL/ELT problems by proposing and implementing tactical/Strategic solutions.
• Desire to mentor junior team members and develop skills.
• Strong documentation and presentation skills.
• Experience in UNIX and Scheduling tools.
• Snowflake experience/certification
• Banking domain experience and DBT experience
• Bigdata, Python, and Spark Knowledge

Qualifications: BA in Data Science with 2 years of Experience.

• Experience working on complex projects with a leadership role as a Specialist
• Experience in performing data analysis, data requirement documentation, data preparation, data migration and/or data governance activities.
• Experience in implementing complex SQL programming analytical, aggregate, join, and/or set operators and commands.
• Experience in performing data analysis to understand and document data profiling rules, data cleansing rules and data transformation rules for data migration projects.
• Demonstrated hands-on experience with designing, implementing and maintaining conceptual, logical and physical data models in Online Transactional Processing (OLTP) and/or Online Analytical Processing (OLAP) environments.
• Experience in creating complex Oracle SQL queries, scripts, views and materialized views leveraging analytical, aggregate, join, and/or set operators to extract, compare and/or analyze data.
• Experience in the creation of technical documentation such as data requirements, data dictionaries, data lineage, source-to-target data mapping, gap analysis and data flow diagrams, and/or other UML diagramming techniques.
• Experience in leveraging data migration strategies and data modeling methodologies such as Kimball and Inmon including star schema, snowflake schema, normalization forms, denormalization, etc.
• Demonstrated hands-on experience using a data modeling tool (Erwin Data Modeler).
• Experience creating test plans and cases for data migration validation activities.
• Demonstrated hands-on experience using business glossary and metadata manager software.
• Experience with Health and Human Services applications performing data analysis activities.

Qualifications: BA in Software Engineering with 7 years of Experience.

• Experience in GCP BigQuery, SQL, and Unix shell scripting.
• Strong in UNIX Shell scripting and SQL. Should have experience in writing medium to complex queries.
• Good understanding of GCP (only on data products like Data Flow, Big Query, Cloud SQL, Pubsub etc.), GCP 
• Should have good experience in Requirement analysis and developing Unit test cases
• Good to have experience in Java, GCP Dataflow, and DataProc, with Data Pipeline Projects
• Experienced working with a group of passionate developers in an Agile, high-energy, fast-paced and outcome-oriented environment.
• Experienced with ELT/ETL processes to transform data using Informatica(or any other Tool) who can analyze existing codes to write equivalent codes using Shell Script SQL, Cloud-based technologies. 
• Understanding of Teradata or any other RDBMS system. Can analyze BTEQ or equivalent Scripts and write SQL Queries in modern SQL Environments like Big Query.
• Good to have knowledge of the DataWarehouse systems and Data Marts for complex applications
• Good communication skills

Qualifications: BA in Management Information Systems with 3 years of Experience.

• Must have the ability to communicate effectively verbally and in writing with technical and non-technical audiences.
• Capability to initiate cross-team meetings, stand-up huddles, and brainstorming sessions when needed to coordinate rapid response to emerging issues.
• Have experience with Data Cloud, Data warehouse, Analytics, and/or Multi-Cloud environments (Amazon, Azure).
• Have the demonstrated ability to manage multiple, complex initiatives in a fast-paced environment.
• Have customer focusing building and maintaining positive relationships with multi-layered teams and staff
• Proven ability to do critical analysis to determine the root cause in a complex environment while weighing the pressure of availability for a mission-critical system
• Must have a commitment to delivering high-quality software and data
• Must demonstrate a sense of urgency, and the ability to work independently and proactively in achieving team and individual objectives
• Must be able to understand the business uses of data and develop designs and specifications to meet those requirements
• Must be comfortable in a dynamic and fast-paced environment
• Experience working with the following technologies and platforms is a plus: Java, Oracle, MySQL, and SQL Server
• Experience in database migration to the Cloud
• Experience in Cloud Data Factory and SQL Server

Qualifications: BA in Information Technology with 7 years of Experience.

• Ability to obtain a Public Trust Clearance
• Experience working with Informatica PowerCenter in an Enterprise Data warehouse
• Expert in Informatica and its features extensively in migrating data to Enterprise Data warehouse
• Experience with full-life implementation of Datawarehouse projects
• Ability to read/write complex queries for data validation and performance tuning techniques for Oracle/Informatica
• Experience optimizing ETL loads and process automation, OLAP Business objects
• Experience working in Agile and/or ITIL framework
• Must have experience developing database applications in.NET Framework, using SQL Server
• Must be familiar with Object Oriented Design and use of Design Patterns
• Must be familiar with ETL Development tools
• Must have strong Data analysis experience
• Must have strong ETL Development
• Must have experience in designing solutions for architecture review
• Must have strong attention to detail and an inquisitive mindset
• Must have experience developing and maintaining system design documentation

Qualifications: BA in Computer Science with 5 years of Experience.