Minimum of 4 years’ experience of working on DW/ETL projects and expert hands-on working knowledge of ETL tools.

• Experience with Data Management & data warehouse development:
• Star schemas, Data Vaults, RDBMS, and ODS
• Change Data capture
• Slowly changing dimensions
• Data governance
• Data quality
• Partitioning and tuning
• Data Stewardship
• Survivorship
• Fuzzy Matching
• Concurrency
• Vertical and horizontal scaling
• ELT, ETL
• Spark, Hadoop, MPP, RDBMS
• Experience with Dev/OPS architecture, implementation and operation
• Hand's on working knowledge of Unix/Linux
• Building Complex SQL Queries. Expert SQL and data analysis skills, ability to debug and fix data issue.
• Complex ETL program design coding
• Experience in Shell Scripting, Batch Scripting.
• Good communication (oral & written) and inter-personal skills
• Expert SQL and data analysis skill, ability to debug and fix data issue
• Work closely with business teams to understand their business needs and participate in requirements gathering, while creating artifacts and seek business approval.
• Helping business define new requirements, Participating in End user meetings to derive and define the business requirement, propose cost effective solutions for data analytics and familiarize the team with the customer needs, specifications, design targets & techniques to support task performance and delivery.
• Propose good design & solutions and adherence to the best Design & Standard practices.
• Review & Propose industry best tools & technology for ever changing business rules and data set. Conduct Proof of Concepts (POC) with new tools & technologies to derive convincing benchmarks.
• Prepare the plan, design and document the architecture, High-Level Topology Design, Functional Design, and review the same with customer IT managers and provide detailed knowledge to the development team to familiarize them with customer requirements, specifications, design standards and techniques.
• Review code developed by other programmers, mentor, guide and monitor their work ensuring adherence to programming and documentation policies.
• Work with functional business analysts to ensure that application programs are functioning as defined.
• Capture user-feedback/comments on the delivered systems and document it for the client and project manager’s review. Review all deliverables before final delivery to client for quality adherence.