Description :

1. Designed and implemented ETL processes to extract, transform, and load data from various sources.
2. Created database objects, including Stored Procedures, Functions, and Views using T-SQL for SQL Server 2012.
3. Utilized SSIS to develop ETL packages for data extraction, transformation, and loading into SQL Server.
4. Developed SSIS design templates for various ETL processes to ensure consistency across projects.
5. Extracted data from multiple sources, including text files and Excel spreadsheets, for integration into the data warehouse.
6. Scheduled and monitored ETL jobs to ensure timely data updates from OLTP systems.
7. Conducted performance tuning on ETL processes to enhance efficiency and reduce runtime.

Experience

0-2 Years

Level

Entry Level

Education

B.S. IT

Description :

1. Developed and implemented ETL job flows for transaction data across 7 financial institutions, ensuring data integrity and accuracy.
2. Created comprehensive mid-month and month-end reports for 9 clients, collaborating with relationship managers to refine reporting processes.
3. Utilized Pentaho Report Designer to publish internal reports, enhancing the visibility of key metrics across departments.
4. Migrated numerous ETL jobs to a Hadoop-based infrastructure, laying the groundwork for a new data warehouse.
5. Engaged with multiple business and technology teams to gather product requirements for the Business Intelligence unit.
6. Generated and deployed reports using SQL Server Reporting Services (SSRS), increasing accessibility for end-users.
7. Designed parameterized reports with cascading parameters in SSRS, aligning report outputs with business requirements.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Designed and implemented ETL processes to update the central data warehouse from mainframe and transactional databases.
2. Developed data models and processes, including weekly snapshots for unemployment compensation data.
3. Established data warehousing standards for managing slowly changing dimensions.
4. Tested and optimized data cube structures and ETL processes for performance metrics.
5. Collaborated on the CMR project to manage audio unemployment compensation requests and background utilities.
6. Worked closely with data warehouse and reporting teams to enhance data accessibility.
7. Created and maintained documentation for data warehouse architecture and processes.

Experience

2-5 Years

Level

Executive

Education

B.S. Computer Science

Description :

1. Gathered and documented functional and technical requirements in collaboration with business analysts to design ETL processes and data models.
2. Developed low-level designs for database sequences, constraints, triggers, and stored procedures, ensuring optimal functionality.
3. Implemented loading techniques such as Slowly Changing Dimensions and Incremental Loading, enhancing data freshness and relevance.
4. Utilized Informatica PowerCenter tools for data transformation and workflow management, employing various active transformations for efficient data processing.
5. Created automated batch files to streamline the execution of workflows and sessions, improving operational efficiency.
6. Designed workflows for task automation, including email notifications and event-triggered mappings, to enhance process responsiveness.
7. Conducted performance tuning at multiple levels to optimize ETL mappings and sessions, significantly improving data processing speeds.

Experience

5-7 Years

Level

Consultant

Education

B.S. CS

Description :

1. Redesigned ETL procedures to align with evolving business requirements, enhancing reporting capabilities using Cognos and T-SQL.
2. Analyzed and resolved data performance issues within E.piphany campaign BI, utilizing T-SQL and BCP for optimization.
3. Created and optimized mappings in Informatica Designer, focusing on incremental data loading and reusable transformations.
4. Conducted thorough unit testing and UAT to ensure accurate data extraction from diverse source systems.
5. Engineered data pipelines and ELT processes for both structured and semi-structured data sources, ensuring reliability and efficiency.
6. Applied MS SQL best practices within OLTP and data warehouse environments to enhance performance.
7. Automated ETL processes for seamless data maintenance and integrity in the data warehouse.

Experience

5-7 Years

Level

Senior

Education

M.S. DS

Description :

1. Redesigned and implemented EA's Pogo data warehouse, enhancing data retrieval efficiency for users.
2. Provided comprehensive insights into user behavior, enabling targeted marketing strategies that improved customer engagement.
3. Delivered actionable game statistics to development teams, driving feature enhancements in future releases.
4. Led the redesign and modeling of the Pogo data warehouse, gathering business requirements and analyzing source systems to optimize ETL architecture.
5. Designed, tested, and implemented robust ETL programs using Informatica and shell scripting.
6. Created and scheduled insightful reports with MicroStrategy, integrating big data insights from Hadoop for mobile applications.
7. Migrated and consolidated Informatica environments to reduce costs while maintaining ongoing support for new business requests.

Experience

5-7 Years

Level

Senior

Education

M.S. CS

Description :

1. Designed and implemented comprehensive data warehouse solutions, ensuring alignment with business objectives.
2. Executed ETL processes to extract, transform, and load data from multiple sources into the data warehouse.
3. Collaborated with business units to gather requirements and translate them into technical specifications for data architecture.
4. Optimized database performance and implemented monitoring tools to enhance system reliability and efficiency.
5. Developed data models that support reporting and analytics, ensuring data integrity and accessibility.
6. Facilitated training sessions for end-users on data access and reporting tools to maximize adoption.
7. Conducted regular audits of data processes and systems to identify opportunities for improvement.

Experience

10+ Years

Level

Executive

Education

M.S. Data Analytics

Description :

1. Facilitated the extraction, transformation, and loading (ETL) of data into data marts, ensuring high-quality data integration.
2. Designed and optimized database schemas, including star schemas and snowflake schemas for improved analytics.
3. Developed complex SQL queries and stored procedures to support reporting and data analysis efforts.
4. Utilized data visualization tools to present insights and trends effectively.
5. Conducted performance tuning of ETL processes and SQL queries to enhance system efficiency and data accessibility.
6. Maintained documentation for data models, ETL processes, and reporting structures to ensure compliance and knowledge transfer.
7. Led troubleshooting efforts to resolve data discrepancies, ensuring data accuracy and integrity across systems.

Experience

7-10 Years

Level

Executive

Education

B.S. in CS

Description :

1. Collaborated with an engineering team in an agile environment, managing tasks and communicating effectively with stakeholders.
2. Participated in code reviews to ensure data warehouse adherence to quality standards.
3. Designed and revised data models and metadata for the enterprise data warehouse.
4. Engaged with business users to gather requirements and refine database designs.
5. Documented metadata for data warehouse systems in compliance with industry standards.
6. Oversaw data loads and performance strategies, serving as a technical lead for business intelligence reporting.
7. Created ER diagrams to define entities, relationships, and business rules for data warehousing.

Experience

0-2 Years

Level

Fresher

Education

B.S. Comp Sci

Description :

1. Developed custom scripts for data manipulation and transformation tasks.
2. Worked with big data technologies to handle large-scale data processing.
3. Created reports using SAP Business Objects, troubleshooting data issues and prioritizing projects with business users.
4. Conducted performance tuning of ETL processes to reduce execution time.
5. Collaborated with business users to define key performance indicators (KPIs).
6. Migrated a shared development server to a continuous integration environment using Visual Studio, SSIS, SSAS, SSRS, and TFS.
7. Implemented data archiving strategies to manage storage costs effectively.

Experience

2-5 Years

Level

Executive

Education

B.S. in CS