• Work with Keeps current with IT blueprint, frameworks and technologies that would benefit and improve efficiency
• Involved in architecture, design, development, and delivery of high-quality, timely, and maintainable software solutions in an Agile environment that meets business requirements.
• Gains domain expertise for the functional and technical areas of focus.
• Shows eagerness to broaden understanding and knowledge of domain and technology and works toward innovative solutions to improve efficiency.
• Develops insights using large data sets enabling timely decision making.
• Lead and Maintain overall ETL integration architecture landscape, roadmap and technology evolution
• Work closely with business partners to help translate functional requirements into technical approaches, designs and decisions
• Understand requirements, Data models, and sources to target mappings
• Conduct impact assessment and determine the size of implementation efforts
• Craft and build data integration workflows
• Work with multi-site remote teams for an understanding of core work, technology, and strategic objectives 
• Participate in the definition of functional and non-functional requirements that define the Integration and Analytics delivery strategy
• Ensuring applications enforce architecture standards, risk and security guidelines, and data management policies
• Work on areas of improvement such as performance tuning, archival and security of data
• Discover new opportunities where analytical techniques can be proven for solving business problems

Skills: IT Frameworks, Software Development, Domain Expertise, Data Analysis, ETL Architecture, Requirements Translation, Data Integration, Security Compliance.

• Playing a lead role in software design, architecture, requirements analysis, investigation of leading-edge technologies, and software development.
• Collaborating with the core development team and the product owner to define and estimate business requirements and then translate these into specific software tasks.
• Collaborate as a member of an agile team to get products developed and completed with best-in-class software development.
• Design, build, and maintain high-performance, reusable, and reliable ETL packages.
• Ensure the best possible performance, quality, and responsiveness of applications developed.
• Create, prioritize, assign, and regularly follow up on tasks and the advancement of the team’s work with regard to deliverables.
• Coordinate with offshore team for deliverables and own them
• Coordinate and assist with several customer and Cognizant teams
• Proactive in identifying any issues and looking for better solutions

Skills: Software Architecture, Requirements Analysis, Agile Development, ETL Development, Performance Optimization, Task Management, Offshore Coordination, Problem Solving.

• Design, develop, and implement end-to-end data solutions (storage, integration, processing, access) in AWS
• Architect and implement ETL and data movement solutions using big data ETL tools: Talend, Glue, etc.
• Prepare documentation and designs for AWS data solutions and applications
• Design and implement distributed analytics platforms for analyst teams
• Migrate data from traditional relational database systems to AWS relational databases such as Amazon RDS, Aurora, and Redshift
• Implement ad-hoc analysis solutions using Athena
• Take ownership of technical solutions from a design and architecture perspective for projects in the presales phase as well as ongoing projects.
• Perform data manipulations, load, and extract from several sources of data into another schema.

Skills: AWS Data Solutions, ETL Development, Big Data Tools, Data Migration, Distributed Analytics, Ad-Hoc Analysis, Solution Architecture, Data Integration.

• Evaluates, selects, tests, and optimizes ETL processes for optimal data availability and quality.
• Work with business requirements analysts to identify and understand source data systems.
• Map source system data to the enterprise data warehouse models.
• Design, develop, and test high-quality extraction, transformation, and load (ETL) processes.
• Set standards for the definition and capture of metadata and rules associated with ETL processes. 
• Adapt ETL processes to accommodate changes in source systems and new business user requirements.
• Works with the Enterprise Data Management team for the development of logical and physical data models, ETL scripts, metadata definitions and models, queries and reports, schedules, work processes, and maintenance procedures.
• Work with business stakeholders regarding identification techniques, documentation, and resolution of data quality issues.
• Manage and establish standards for naming and abbreviation conventions, data definitions, ownership, documentation, procedures, and techniques.
• Support the development of integrated data models and artifacts identifying as-is, planned, and to-be mission data and supporting metadata 

Skills: ETL Optimization, Data Mapping, Data Warehouse Modeling, Metadata Management, Requirements Analysis, Data Quality, Data Modeling, ETL Standards.

• Design, maintenance, and implementation of the ETL architecture
• Model objects/mappings for use in ETL environments
• Participate in architectural discussions /workshops 
• Review design and test documents, maintain artifacts
• Share the existing architecture/integration standards and related documentation
• Revise and maintain the server deployment Topology
• Road Map and strategy for architectural improvement.
• Work with business, process teams, and leaders, to understand business information requirements and to classify, organize, make available, and govern the data needed to meet those requirements. 

Skills: ETL Architecture, Data Modeling, Architectural Discussions, Document Review, Integration Standards, Server Topology, Improvement Strategy, Data Governance.

• ETL design experience and Hadoop experience
• Must have an understanding of ETL design principles
• Abinitio development experience
• Communication skills
• Security tool experience (like tokenization, encryption, etc.)
• Experience with various file types including JSON, Parquet, and text.
• Experience in any cloud platform
• Have the ability to thrive in a fast, sophisticated environment and can take care of ambiguous situations
• Ability to be creative and tackle complex problems
• Possess skills to communicate and build positive relationships with business and other key partners
• Experience and desire to work in a Global delivery environment
• Ability to work in a team in diverse/ multiple stakeholder environment

Qualifications: BA in Computer Science with 5 years of Experience

• Strong technical and problem-resolution skills
• Experience as an ETL Architect.
• Experience in modeling and business system designs.
• Proven experience managing simultaneous projects.
• Knowledge of big data architectures and concepts is highly valued.
• Established background in leveraging the latest state-of-the-art technologies for optimal data delivery, including but not limited to data virtualization, event stream, and replication.
• Highly functional understanding and background in the use of ETL tools (e.g., SSIS).
• Comprehensive understanding of customer data matching techniques (i.e., Master Data Management for customers, products, etc.)
• Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
• Proven analytical and problem-solving abilities.
• Knowledge of the Sarbanes Oxley Act and its impact on data security and change management controls.

Qualifications: BA in Information Technology with 6 years of Experience

• Strong development experience in Informatica (ETL), DataStage
• Strong experience in Informatica PowerCenter, BDM, IICS, Python, SQL, Hive, Impala
• Experience with Oracle, PL/SQL databases
• Experience on both on-prem / Azure cloud platform
• Experience in Data Analytics
• Experience in Data Modeling, Schema Design, ETL Design
• Experience in working with ETL tools to import data into Snowflake, Create simple BI reports
• Experience in ETL + DWH hands-on Architect role.
• Experience in cloud databases like Redshift, SQL Server Azure, EMR/Athena, and new ETL tools like Matillion

Qualifications: BA in Software Engineering with 7 years of Experience

• Excellent command over MS SSIS (ETL).
• Should have extensive exposure to database designing and modeling.
• Excellent command over MS SQL Server database and Transact SQL.
• Should be very confident in UDF functions, procedures, triggers, Aggregate functions, CTE, temporary tables, and Scheduled jobs. 
• Excellent command over PowerShell scripting. 
• Expertise in data warehousing ETL architecture Data Profiling Experience in working with various versions of Informatica PowerCenter, Talend Oracle warehouse Builder Client and Server tools
• Expertise in tuning the performance of mappings and determining the performance bottlenecks Experience in creating pre-session and post-session scripts to ensure timely accurate processing and balancing of job runs
• Experience in integration of various data sources like SQL Server Oracle Tera Data Flat files DB2 Mainframes
• Strong experience in complex PLSQL packages functions cursors triggers views materialized views TSQL DTS defining business process deliver project roadmap including documentation initial source data definition mapping detailed ETL development specifications and operations
• Ability to communicate effectively across internal and external organizations
• Ability to work independently and self-motivated, well organized.

Qualifications: BA in Engineering with 8 years of Experience

• Hands-on experience in the design and implementation of Data Warehousing solutions
• Strong understanding of the Amdocs Data model and its implementation.
• Have built at least two Enterprise Data Warehouses from scratch
• Must possess complete hands-on experience in any RDBMS such as Oracle, Teradata, and SQL Server
• Strong knowledge of SQL and procedural languages such as T-SQL, PL/SQL etc.
• Hands-on experience Informatica ETL Tool
• Good to have experience in the Cognos Visualization tool
• Hands-on experience in dealing with different ERP and CRM data sources like Siebel, JDE and SAP
• Must have hands-on experience in relational and dimensional modeling
• Must have hands-on experience in designing Corporate Information Factory model (3NF)
• Data Modeling Expertise Conceptual, Logical Physical in both Relational Dimensional
• In-depth knowledge of at least one designing/modeling tool such as Erwin, ER Studio, PowerDesigner, etc.
• Must have experience in understanding business vision to prepare ETL solution architecture
• Well-experienced in designing ETL/ELT approaches while authoring the data flows
• Must have experience in presenting technical topics to large audiences

Qualifications: BA in Data Science with 4 years of Experience